Expected Supplier Rebates Table - SET 10

This file enables you to define expected supplier rebates that reduce landed cost within the Receiving System. Receiving programs use this feature only for warehouses that have the following settings activated in the Warehouse Settings File (SET 14).

• Use Extra Receiving Features
• Use Additional Freight Table

The Expected Supplier Rebates Table has to be activated by individual warehouse via the Warehouse Settings Table (SET 14).

Field	Description
Company Number	Enter the company number that the expected rebate is being established for.
Manufacturer	Enter a manufacturer code or ? to search for a list of manufacturers to choose from.
Product Line	Enter the product line, or ? to search for a list of products, or *** for all other product lines.
Supplier	Enter supplier code, or ? to search for a list of suppliers, or *** for all suppliers. The supplier that you select will be assigned the expected rebate.
G/L Account	Enter the account number or ? to scan for a list of account numbers. This account number will be assigned the expected rebate.
Cost Center	Enter the cost center or ? to scan a list of cost centers. The cost center will be assigned the expected rebate.
Rebate Percentage	Enter in the supplier's rebate percentage, if applicable. Notice one of the entries in the example screen shows a negative number (2.00000 -). The ability to use negative numbers allows you to create a markup percentage to the inventory value for margin purposes. This markup is kept separate from the base cost and is recorded separately in order to post to a specific general ledger account. This functionality can be used for one time events such as special buys, where you do not want to reflect a lower cost for the special shipment when it is added to inventory. By adding a negative number, you are adding to the cost of the inventory; which is applied upon inventory receipt. A negative rebate percentage adds to the receipt value and a positive percentage reduces the cost in receiving.

Associated Files

Warehouse Settings (SET 14)

• The Use Expected Supplier Rebate Table field has to be activated to use the Expected Supplier Rebate Table when receiving.

Inventory To G/L Interface File (ACT 103)

This file maps the Suppler Rebate for posting to the correct Chart of Accounts.

• Using the extended format, select a company, and then select Receipts.
• On the next screen to appear, select Stock and Special Orders.
• Select System Level settings for both warehouses and cost centers.
• Enter GL accounts in the Expected Rebates field.